100
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
procedure TForm1.Pivot1Click(ASender: TObject; );
begin
	with Pivot1 do
	begin
		ClearFilter();
	end
end;

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
99
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib_TLB.exFilterBarVisible) Or Integer(EXPIVOTLib_TLB.exFilterBarPromptVisible);
	EndUpdate();
end
98
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
97
Is it possible to prevent closing the control's filter bar, so it is always shown

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FilterBarCaption := 'len(value) = 0 ? `<fgcolor=808080>no filter` : value';
	FilterBarPromptVisible := EXPIVOTLib_TLB.exFilterBarVisible;
	EndUpdate();
end
96
How can I find if the control is running in DPI mode
with Pivot1 do
begin
	OutputDebugString( FormatABC('dpi = 1 ? `normal/stretch mode` : `dpi mode`',Null,Null,Null) );
end
95
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. It s possible to setting up this parameters
with Pivot1 do
begin
	DisplayPivotData := -1;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end
94
How do I change the drop down filter icon/button (white)

with Pivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' + 
	'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' + 
	'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' + 
	'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' + 
	'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' + 
	'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
		Add(1,'CP:2 -6 -4 2 4');
	end;
	Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $1000000;
	Background[EXPIVOTLib_TLB.exCursorHoverColumn] := BackColor;
	HeaderVisible := True;
	HeaderHeight := 24;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
	PivotBarVisible := EXPIVOTLib_TLB.exPivotBarVisible;
	EndUpdate();
end
93
How do I change the drop down filter icon/button (black)

with Pivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQg' + 
	'mPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThd' + 
	'r4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA');
	end;
	Background[EXPIVOTLib_TLB.exHeaderFilterBarButton] := $1000000;
	Background[EXPIVOTLib_TLB.exCursorHoverColumn] := $ffffffff;
	BackColorHeader := RGB(0,0,0);
	ForeColorHeader := RGB(255,255,255);
	HeaderVisible := True;
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
	EndUpdate();
end
92
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control

with Pivot1 do
begin
	BeginUpdate();
	BackColorAlternate := $7ff0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12';
	PivotColumns := 'sum(5)';
	EndUpdate();
end
91
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( 'Type of ColumnFromPoint: ' );
		OutputDebugString( ColumnFromPoint[-1,-1] );
		OutputDebugString( ' should not be VT_NULL' );
		OutputDebugString( 'Type of ValueFromPoint: ' );
		OutputDebugString( ValueFromPoint[-1,-1] );
		OutputDebugString( ' should be VT_NULL' );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
end
90
What should I set FormatPivotHeader to, to show it on the columns header only

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + ( ( display=1 ? `<c>Date: <' + 
	'b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )';
	EndUpdate();
end
89
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + `<r>ReportDate: ' + 
	'` + date(`now`)';
	EndUpdate();
end
88
Is it possible to display aggregate result on parent rows as well

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib_TLB.exNoLines;
	ShowBranchRows := Integer(EXPIVOTLib_TLB.exBranchIncludeAggregate) Or Integer(EXPIVOTLib_TLB.exBranchTree);
	EndUpdate();
end
87
How do I show expanded/collapsed rows

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib_TLB.exNoLines;
	EndUpdate();
end
86
How do I show expanded/collapsed columns

with Pivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)';
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	EndUpdate();
end
85
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '' )'') : caption)';
	EndUpdate();
end
84
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( 'DataColumn' );
		OutputDebugString( DataColumnFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
83
Is there any way for the user to change the alignment at runtime (using excontextmenu)

// RClick event - Occurs once the user right clicks the control.
procedure TForm1.Pivot1RClick(ASender: TObject; );
begin
	with Pivot1 do
	begin
		h := DataColumns.item[OleVariant(5)].Alignment;
		c := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.ContextMenu'))) as EXCONTEXTMENULib_TLB.ExContextMenu);
		with c do
		begin
			FlatImageWidth := 0;
			ToString := 'Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp=' + 
		'100][close=0][id=2])';
			item[OleVariant(h)].Checked := True;
			h := Select(Null,Null,Null);
		end;
		with DataColumns.item[OleVariant(5)] do
		begin
			Alignment := h;
			HeaderAlignment := h;
		end;
		Refresh();
	end
end;

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
82
Is there any way for the user to change the alignment at runtime

// RClick event - Occurs once the user right clicks the control.
procedure TForm1.Pivot1RClick(ASender: TObject; );
begin
	with Pivot1 do
	begin
		OutputDebugString( 'The column gets aligned to the center' );
		with DataColumns.item[OleVariant(5)] do
		begin
			Alignment := EXPIVOTLib_TLB.CenterAlignment;
			HeaderAlignment := EXPIVOTLib_TLB.CenterAlignment;
		end;
		Refresh();
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
81
How can I align a column to the right

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item[OleVariant(5)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
80
How can I display the control's content on an single A3 paper size, when using PDF format
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['C:\Temp\Preview.pdf|11.69 in x 16.53 in||single'];
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
79
How can I display the control's content on an A3 paper size, when using PDF format
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['C:\Temp\Preview.pdf|11.69 in x 16.53 in'];
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
78
How can I export the control's content to a PDF document (method 1)
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	EndUpdate();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		PrintExt := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		CopyTo('c:/temp/xtest.pdf');
	end;
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
77
How can I export the control's content to a PDF document (method 2)
with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := CopyTo['c:/temp/xtest.pdf'];
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
76
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it 
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	DisplayFilterList := EXPIVOTLib_TLB.exNoItems;
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarReadOnly) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Refresh();
end
75
Is it possible to edit the conditional-expression at runtime

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.Add('custom','custom','') do
	begin
		Bold := True;
		FontSize := 12;
		Expression := 'value > 2000';
		ContextEditExpression := True;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[custom]/12';
	EndUpdate();
end
74
How can I highlight values using EBN colors

with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatConditionalAppearances.item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	EndUpdate();
end
73
How do I mark not-empty values in the chart

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	EndUpdate();
end
72
How can I highlight negative and positive values in the same chart

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive]/12';
	EndUpdate();
end
71
How can I highlight values that starts with a letter

with Pivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('f','starts with f','lower(value) startwith `f`') do
	begin
		Expression := 'lower(value) startwith `f`';
		Shadow := $1;
		ShadowOffset := 0;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[f]';
	EndUpdate();
end
70
How can I mark values greater than a value, 100 for instance

with Pivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('greater100','>100','value > 100') do
	begin
		Expression := '( dbl(value) != 0 ) ? (value > 100) : 0';
		ForeColor := $ff;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[greater100,content=numeric]';
	EndUpdate();
end
69
How can I remove the Conditional context-menu

with Pivot1 do
begin
	BeginUpdate();
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	EndUpdate();
end
68
How do change the way the negative/positive numbers show when using conditional-format

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.item['negative'] do
	begin
		BackColor := $0;
		ForeColor := $808080;
		FontSize := 8;
	end;
	with FormatConditionalAppearances.item['positive'] do
	begin
		BackColor := $0;
		ForeColor := $1;
		FontSize := 11;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive,content=numeric]';
	EndUpdate();
end
67
How do I highlight the negative values with white color or black

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with FormatConditionalAppearances.item['negative'] do
	begin
		BackColor := $1;
		ForeColor := $ffffff;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
66
Does your control support conditional-format, so I can highlight certain values

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
65
How do I add a computed column/field, like VAT for instance (method 2)

with Pivot1 do
begin
	BeginUpdate();
	with Aggregates do
	begin
		Add('vat19','sum','VAT 19%','VAT 19%').FormatValue := 'value * 0.19';
		Add('vat24','sum','VAT 24%','VAT 24%').FormatValue := 'value * 0.24';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]';
	EndUpdate();
end
64
How do I add a computed column/field, like VAT for instance (method 1)

with Pivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('vat19','VAT 19%',Null) do
	begin
		Expression := 'len(value) ? ((value * 1.19) format '''') : ''''';
	end;
	with FormatContents.Add('vat24','VAT 24%',Null) do
	begin
		Expression := 'len(value) ? ((value * 1.24) format '''') : ''''';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]';
	EndUpdate();
end
63
How can I hide some values for instance negative values

with Pivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('hiden','hide negative',Null) do
	begin
		Expression := 'value < 0 ? `` : value';
	end;
	with FormatContents.Add('hidep','hide positive',Null) do
	begin
		Expression := 'value > 0 ? `` : value';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]';
	EndUpdate();
end
62
How can I decode the Layout property

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		OutputDebugString( Decode64TextW[Pivot1.Layout] );
	end;
	EndUpdate();
end
61
How can I specify the sorting type, so the column gets sorted as numeric for instance

with Pivot1 do
begin
	Import('1,1#11,11#101,101','eor=''#'' eof='','' hdr=0');
	with DataColumns.item[OleVariant(0)] do
	begin
		Caption := 'Numeric';
		SortType := EXPIVOTLib_TLB.SortNumeric;
	end;
	DataColumns.item[OleVariant(1)].Caption := 'String (default)';
	PivotRows := '0';
	Refresh();
end
60
How can I disable the control's context menu
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
59
How do I get the captions of the columns
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	OutputDebugString( DataColumns.Count );
	OutputDebugString( DataColumns.item[OleVariant(0)].PivotCaption );
	OutputDebugString( DataColumns.item[OleVariant(0)].Caption );
	OutputDebugString( DataColumns.item[OleVariant(1)].PivotCaption );
	OutputDebugString( DataColumns.item[OleVariant(1)].Caption );
end
58
How can I specify the default-format for a specified column, so it always shows as numeric for instance
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item['Freight'] do
	begin
		DefaultFormatContent := 'numeric';
		DefaultFormatAppearances := 'bold';
		SortOrder := EXPIVOTLib_TLB.SortAscending;
		SortType := EXPIVOTLib_TLB.SortNumeric;
	end;
	PivotTotalDefaultFormatContent := 'currency';
	PivotTotalDefaultFormatAppearances := 'strikeout,bold';
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold,content=numeric]';
	PivotTotals := 'sum[strikeout,bold,content=currency]';
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
	Refresh();
end
57
How can I display the percentage column

with Pivot1 do
begin
	FormatContents.Add('percent','value + `%`',Null);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '5[content=percent]';
	Refresh();
end
56
How do I change the name for months in the drop-down filter window (localization)

with Pivot1 do
begin
	OutputDebugString( Description[EXPIVOTLib_TLB.exFilterBarDateMonths] );
	Description[EXPIVOTLib_TLB.exFilterBarDateMonths] := 'Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie';
	Description[EXPIVOTLib_TLB.exFilterBarAll] := '(Toate)';
	Description[EXPIVOTLib_TLB.exFilterBarBlanks] := '(Gol)';
	Description[EXPIVOTLib_TLB.exFilterBarNonBlanks] := '(Plin)';
	Description[EXPIVOTLib_TLB.exFilterBarFilterForCaption] := 'Filtreaza:';
	Description[EXPIVOTLib_TLB.exFilterBarDateTodayCaption] := 'Azi';
	Description[EXPIVOTLib_TLB.exFilterBarDateWeekDays] := 'D L Ma Mi J V S';
	Description[EXPIVOTLib_TLB.exFilterBarExclude] := 'Exclud';
	Description[EXPIVOTLib_TLB.exColumnsFloatBar] := 'Coloane';
	Description[EXPIVOTLib_TLB.exFilterBarAnd] := 'si';
	Description[EXPIVOTLib_TLB.exFilterBarDate] := 'Data:';
	Description[EXPIVOTLib_TLB.exFilterBarDateTitle] := 'Data';
	Description[EXPIVOTLib_TLB.exFilterBarDateTo] := 'la';
	Description[EXPIVOTLib_TLB.exFilterBarNot] := 'nu';
	Description[EXPIVOTLib_TLB.exFilterBarOr] := 'sau';
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.item['OrderDate'].SortType := EXPIVOTLib_TLB.SortDate;
	PivotRows := '9';
	Refresh();
end
55
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = x 5';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
54
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = 5 x';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
53
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( ColumnFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Refresh();
end
52
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TForm1.Pivot1MouseMove(ASender: TObject; Button : Smallint;Shift : Smallint;X : Integer;Y : Integer);
begin
	with Pivot1 do
	begin
		OutputDebugString( ValueFromPoint[-1,-1] );
	end
end;

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Refresh();
end
51
How can I specify a column to display HTML format

with Pivot1 do
begin
	Import('Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6','eor=''#'' eof='','' hdr=0');
	DataColumns.item[OleVariant(0)].HTML := True;
	DataColumns.item[OleVariant(1)].HTML := True;
	PivotRows := '0';
	Refresh();
end
50
Does your control supports scrolling by touching the screen

with Pivot1 do
begin
	rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset'))) as ADODB_TLB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Null);
	end;
	DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
	AutoDrag := Integer(EXPIVOTLib_TLB.exAutoDragScrollOnShortTouch) Or Integer(EXPIVOTLib_TLB.exAutoDragScroll);
end
49
How can I specify programatically the width of the pivot column ( first column )

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	EndUpdate();
end
48
How can I show the total of each row, when columns are shown as expanded

with Pivot1 do
begin
	BeginUpdate();
	IncludeExpandColumn := EXPIVOTLib_TLB.exIncludeExpandColumn;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	EndUpdate();
end
47
How can I prevent grouping by a specified column
with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.item['Freight'].AllowGroupBy := EXPIVOTLib_TLB.exGroupByNone;
end
46
How can I sort alphabetically the columns to be displayed in the context menu/floating panel

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarContextSortAscending) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
	PivotColumnsSortOrder := EXPIVOTLib_TLB.exPivotColumnsAscending;
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
end
45
How can I prevent dropping data to the control
with Pivot1 do
begin
	AllowDrop := False;
end
44
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus

with Pivot1 do
begin
	var_DisplayFilterList := DisplayFilterList;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exHideFilterPattern) Or Integer(EXPIVOTLib_TLB.exFilterListDefault);
end
43
How can I prevent showing the Filter For field in the drop down filter window

with Pivot1 do
begin
	var_DisplayFilterList := DisplayFilterList;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exHideFilterPattern) Or Integer(EXPIVOTLib_TLB.exFilterListDefault);
end
42
How can I display the numeric columns only when selecting a new aggregate, like SUM

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold]';
	PivotColumns := 'sum(5)/12,count(5)/12';
	DataColumns.item['Freight'].SortType := EXPIVOTLib_TLB.SortNumeric;
end
41
How can I add a value column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
end
40
I would like to always have the subtotals in the same row of the "father row". Could that be done

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold],2';
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := Integer(EXPIVOTLib_TLB.exViewCompactAggregates) Or Integer(EXPIVOTLib_TLB.exViewCompact);
	PivotTotals := '/sum,sum(0)';
end
39
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
	PivotColumns := 'sum(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI=''],count(5)/12[filter=''gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZr' + 
	'MJnMoAgI='']';
	ShowViewCompact := Integer(EXPIVOTLib_TLB.exViewCompactKeepSettings) Or Integer(EXPIVOTLib_TLB.exViewCompact);
end
38
How can I summarize more fields in the same cell

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
	PivotColumns := 'sum(5)/12,count(5)/12';
	ShowViewCompact := EXPIVOTLib_TLB.exViewCompact;
end
37
How do I programmatically group by rows, in a compact way, no hierarchy lines

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,2';
	ShowBranchRows := EXPIVOTLib_TLB.exBranchCompact;
end
36
How do I programmatically group by rows

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	LinesAtRoot := EXPIVOTLib_TLB.exLinesAtRoot;
	HasLines := EXPIVOTLib_TLB.exSolidLine;
end
35
How do I programmatically group by columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12;6';
end
34
How can I hide the add new button on the pivot bar

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarHideAddNew) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
33
Is it possible to show the data that generated the result, when double clicking the row

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	ShowDataOnDblClick := True;
	EndUpdate();
end
32
Does your control support subscript or superscript, in HTML captions

with Pivot1 do
begin
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DataColumns.item['ShipCountry'].Caption := 'ShipCountry<font ;7><off 6><sha ;;0>subscript';
	DataColumns.item['ShipRegion'].Caption := 'ShipRegion<font ;7><off -6><sha ;;0>superscript';
	Refresh();
end
31
Is it possible to define a different background color for the pivot bar

with Pivot1 do
begin
	Background[EXPIVOTLib_TLB.exPivotBarBackColor] := $f0f0f0;
end
30
How can I display an icon/image to Content sub-menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	FormatContents.item['numeric'].Name := '<img>1</img> Numeric';
	PivotRows := '5[content=numeric]';
end
29
How can I change the selection background in the control's context menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Background[EXPIVOTLib_TLB.exSelBackColorFilter] := $ff;
end
28
How can I display the column as date in a long format

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatContents.Add('longdate','longdate(date(value))',Null);
	PivotRows := '9[content=longdate]';
end
27
Is it possible to display the column in upper-case

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatContents.Add('upper','upper(value)',Null);
	PivotRows := '0[content=upper]';
end
26
How can I programatically bold a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[bold]';
end
25
How can I display the total with a different foreground color

with Pivot1 do
begin
	FormatAppearances.Add('fore',Null).ForeColor := $ff;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[fore,bold]';
end
24
How can I display the total with a different background color/ebn 

with Pivot1 do
begin
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	FormatAppearances.Add('back',Null).BackColor := $1000000;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end
23
How can I display the total with a solid background color

with Pivot1 do
begin
	FormatAppearances.Add('back',Null).BackColor := $f0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum[back]';
end
22
Is it possible to change the "bold" caption in the control's context menu

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatAppearances.item['bold'].Name := 'Ingrosat';
end
21
Is it possible to show no Exclude field in the filter window

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := Integer(EXPIVOTLib_TLB.exShowCheckBox) Or Integer(EXPIVOTLib_TLB.exSortItemsAsc);
end
20
How can I prevent showing the drop down filter button

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	DisplayFilterList := EXPIVOTLib_TLB.exNoItems;
end
19
How do I get the count of positive values only

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Aggregates.Add('positive','sum',Null,Null).FormatValue := 'value < 0 ? 0 : 1';
	PivotRows := '0';
	PivotColumns := 'positive(5)';
end
18
How do I get the sum for negative values only

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	Aggregates.Add('negative','sum',Null,Null).FormatValue := 'value < 0 ? value : 0';
	PivotRows := '0';
	PivotColumns := 'negative(5)';
end
17
My data stores the data as strings, is it possible to load the data using Import method

with Pivot1 do
begin
	Import('''string 1'';''string 2''#''string 3'';''string 4''','str=`''` eor=''#'' eof='';'' hdr=0');
end
16
Is it possible to load data using different separators

with Pivot1 do
begin
	Import('item 1;item 2#item 3;item 4','eor=''#'' eof='';'' hdr=0');
end
15
Is it possible to align a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item[OleVariant(0)] do
	begin
		Alignment := EXPIVOTLib_TLB.RightAlignment;
		HeaderAlignment := EXPIVOTLib_TLB.RightAlignment;
	end;
	Refresh();
end
14
How can I change by code the column/rows background color

with Pivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	FormatAppearances.Add('aka',Null).BackColor := $1000000;
	PivotRows := '0[aka]';
	EndUpdate();
end
13
How can I apply by code any appearance to my list

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0[italic]';
	PivotColumns := 'count(0)[underline]';
	PivotTotals := 'count[bold,strikeout]';
	EndUpdate();
end
12
How can I display an icon instead SUM/Total field

with Pivot1 do
begin
	BeginUpdate();
	Images('gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAVj' + 
	'ILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJI' + 
	'oyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag==' + 
	'');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with Aggregates.item['sum'] do
	begin
		Name := '<img>1</img> Sum';
		Caption := '<img>1</img>';
	end;
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
	FormatPivotHeader := 'iaggregate ? (caggregate + (iaggregate != 5 ? '' '' : '''') + caption) : caption';
	FormatPivotTotal := 'caggregate';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
11
How can I change the caption to be displayed when dragging an aggregate function

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
	FormatPivotHeader := '(iaggregate ? (''<b>'' + upper(caggregate) + ''</b> of '' + caption) : caption)';
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
10
I am using Import method, just wondering if I can rename the columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	with DataColumns.item[OleVariant(0)] do
	begin
		Caption := 'New Caption';
		PivotCaption := 'New Pivot Caption';
	end;
	Refresh();
end
9
Does your control support Fit-To-Page Print and Print Preview

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	ExpandAll();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		Options := 'FitToPage = On';
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
8
How can I print the control

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0,1,2';
	ExpandAll();
	with (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print'))) as EXPRINTLib_TLB.Print) do
	begin
		PrintExts := (IUnknown(Pivot1.DefaultInterface) as EXPIVOTLib_TLB.Pivot);
		Preview();
	end;
end
7
How can I hide the pivot bar (hide completly)

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoFit) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable);
end
6
How can I hide the pivot bar (auto-hide)

with Pivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib_TLB.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib_TLB.exPivotBarAllowValues) Or Integer(EXPIVOTLib_TLB.exPivotBarAutoHide) Or Integer(EXPIVOTLib_TLB.exPivotBarShowTotals) Or Integer(EXPIVOTLib_TLB.exPivotBarSizable) Or Integer(EXPIVOTLib_TLB.exPivotBarVisible);
end
5
How can I count and get the total of a specified column

with Pivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
	PivotRows := '0';
	PivotColumns := 'sum(5)';
	PivotTotals := 'sum,count';
	EndUpdate();
end
4
How can I add show the columns once I grouped a column

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0';
	PivotColumnsFloatBarVisible := EXPIVOTLib_TLB.exPanelVisible;
end
3
How can I programatically group the columns

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
	PivotRows := '0:D';
end
2
Is it possible to load data from a data source

with Pivot1 do
begin
	rs := (IUnknown(ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset'))) as ADODB_TLB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Null);
	end;
	DataSource := (IUnknown(rs) as ADODB_TLB.Recordset);
end
1
How can I load data

with Pivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Null);
end